package com.qcby.springbootdemotest.dao;
import com.qcby.springbootdemotest.entity.*;

import java.util.List;

public interface ZhiLianDao {

    int insert(ZhiLian zhiLian);

    /**
     * 不同行业的薪资水平查询
     * @return
     */
    List<SalaryAndSector> findBySalaryAndSector();

    /**
     * 各个城市的不同行业的招聘数据量
     * @param address
     * @return
     * */
    List<SectorAndAddress> findCountBySectorAndAddress(String address);

    /**
     * 查询每个城市的某行业的平均薪资
     * @param address
     * @return
     */
    List<SalaryByAddressAndSector> findSalaryByAddressAndSector(String address);

    /**
     * 查询每个行业的某城市的平均薪资
     * @param sector
     * @return
     */
    List<SalaryBySectorAndAddress> findSalaryBySectorAndAddress(String sector);

    /**
     * 各个城市对学历要求的分布
     * @param address
     * @return
     * */
    List<AddressAndEducation> findCountByAddressAndEducation(String address);

    /**
     * 各个行业对经验的要求分布
     * @param sector
     * @return
     * */
    List<SectorAndExperience> findCountBySectorAndExperience(String sector);

    List<AddressAndCount> findAddressAndCount();
}
